A schema is essentially a namespace: it contains named objects (tables, data types, functions, and operators) whose names may duplicate those of other objects existing in other schemas.
The schema name must be distinct from any existing schema name in the current database.
Create Schema
To create a new schema
- Control-click the database in the navigation pane and choose New Schema.
- Edit schema properties on the appropriate tabs of the Schema Designer.
Edit Schema
To edit the existing schema (manage its general etc)
- Control-click the schema in the navigation pane and choose Schema Properties....
- Edit schema properties on the appropriate tabs of the Schema Designer.
Open Schema
To open a schema which shows in the navigation pane
- Double-click the schema to open in the navigation pane.
or - Control-click the schema and choose Open Schema.
Close Schema
To close a schema
- Control-click the schema in the navigation pane and choose Close Schema.
Delete Schema
To delete a schema
- Control-click the schema in the navigation pane and choose Delete Schema.
- Confirm removing in the dialog window.